﻿CREATE TABLE [CoffeeShop].[PurchaseOrderDetail] (
    [PurchaseOrderDetailId]   INT        IDENTITY (1, 1) NOT NULL,
    [PurchaseOrderId]         INT        NOT NULL,
    [Price]                   FLOAT      NOT NULL,
    [Quantity]                INT        NOT NULL,
    [PurchaseOrderStatusCode] NCHAR (10) NOT NULL
);

